Adding a Many to Many Relation

You can also create Many to Many Relationships with business objects. For example, many to many relationships help to track different SKUs and their inventoryThe procedure of checking the availability in one or more warehouses for a specific product. levels with different warehouse locations. Another example is multiple contactsUsers that are created either when an external customer registers on the public site or when a Commerce Manager admin creates them directly from the Commerce Manager; typically, users that are internal to your organization are assigned to organizations or organization units and assigned varying permissions based on role. By default, new users that are created by registering from the public site are given the "Registered" and "Everyone" roles. a part of multiple organizationsGroups or sub-groups of registered users and customers. An organizational unit is a "child" or subsidiary of a "parent" organization. Within Commerce Manager, you can assign an organization as a parent of another organization. For example, the parent company Company X, and the organizational units are Company X West and Company X East. Organization units include regional branches or departments or you could name them by business categories such as "Computer and Electronics" or "Clothing and Accessories." Organizations can be structured into a tree structure with sub-units with different levels of permissions assigned to each. So for example, you can set up your company as a parent level organization while your departments such as Sales & Marketing, IT/Development, and Operations as organization units. With this scenario, you can allow users in each departments to have access to only relevant subsystems, screens and functionality within Commerce Manager. Same as "organization units".. A Many to Many relationship between two objects is also referred to as a Bridge.

In the example both Organization and Organization_Contact = N.

To create a Many to Many relationship, click on a business object and then click on the N:N Relations tab.

Click on New Relation "many to many" to create a new N:N relationship.

The Relation N:N is much different compared to the Relation 1:N/N:1 forms.

1. The Current Object defaults to the name of the Business Object you are editing
2. Select a Related Object from the dropdown menu
3. The Relation Name is autopopulated by (Current Object Name_Related Object Name). Change this name if you wish, but you cannot have spaces or special characters, only letters, numbers, and underscores.
4. Enter in a Friendly Name, which can have special characters and spaces. Make sure both Relation and Friendly Names are unique do not already exist.
5. Under Current Object, select a Display Region where the field will appear.
6. Under Related Object, select a Display Region where the field will appear.

Once all the relevant information is entered, click on Save.

A many to many relationshipMultiple object-related data can be associated or related with multiple objects. For example, different SKUs (Store Keeping Unit) can be associated with one or more Warehouses for tracking and storage is automatically generated for the related object when you click on its N:N tab under its configuration form.

Version: EPiServer Commerce 1 R2 SP2| Last updated: 2012-09-20 | Copyright © EPiServer AB | Send feedback to us